#!/usr/bin/python3
# coding=utf-8
import pandas as pd
df=pd.read_csv("../data/xls/sz002268.csv")
#print(df)
#打印列
columns=df.columns
print("---------------------")
print(columns)
row=df.loc[1952]
print("---------------------")
#打印1952行数据
print(row)

filter_df1=df[(df['date']>'2022-09-21') & (df['close']<28)] #2023-06-1以后的数据
print("---------------------")
print(filter_df1)

print("-----------------")
close=filter_df1['close'].max()
print(close)

filter_df2=filter_df1[filter_df1['close']==close] #查询最高
print(filter_df2)